CREATE PROCEDURE [dbo].IdentificarHorario
AS
BEGIN 

SELECT (SUBSTRING ((CONVERT(VARCHAR,GETDATE(),100)), 13,2)+' '+SUBSTRING ((CONVERT(VARCHAR,GETDATE(),100)), 18,2)) as horarioIdentificado

END